package com.zmj.constant;



public class CommSQL {

	public static final String USER_SELECT = "select * from user where 1=1 ";
	public static final String USER_SELECT_LOGIN = USER_SELECT + " and userName=? and password=?";
	public static final String GOODS_SELEC="SELECT gid,gname,glongname,gprice,gimage,gtype,gdesc,gdistime,gdiscount,gnew,gt.tname gtypename,gt.tdesc gtypedesc FROM goods g LEFT JOIN goods_type gt ON g.gtype = gt.tid WHERE 1=1 "; 
	public static final String LIMIT=" LIMIT ?,?";
	
	
}
